CONTAINS

Returns a Boolean value (TRUE or FALSE) which determines whether a string expression is included in another.

Syntax

CONTAINS(text1, text2)

text1 - string expression (or the reference to a cells) being searched.

text2 - string expression (or the reference to a cells) sought.

Examples

CONTAINS("123456", "56") returns TRUE

CONTAINS("abcdef", "hello") returns FALSE

[ ©2000-2001, Edwin H. B. Tam, All rights reserved ]